-
Re: JOIN 2 numbers and maintain formatting
Hey Cpatt, I'd use something like... =ROUND([Column1]@row, 0) + " - " + ROUND([Column2]@row, 0)1 · -
Re: Automatic Hyperlinking
Hi Abdul, You should be able to use the formula in column C to create the hyperlink... Is that not working for you? Ryan1 · -
Re: Record Date Workflow Issue?
Are you saving and waiting a few seconds? I set mine up like yours and it's working ok... https://youtu.be/dVKyb1ivFnE1 · -
Re: Calculating the number of times a contact name appears in a list
Ah! Your contact column is a multiselect. So we'll need to modify the formula to allow for that... =COUNTIF([Contact Column]:[Contact Column],HAS(@cell, "Kate Condon")) We use the HAS funct…1 · -
Re: Duplicating a Status column to generate a Previous Status
Hi @Renea Davis-Leathers Create an Auto Generated Number column named "Row". Then in your Previous Status Column, add this formula: =INDEX(Status:Status, MATCH(Row@row - 1, Row:Row, 0)) Thi…1 ·